CREATE TABLE STREET 
(ID INT IDENTITY(1,1) NOT NULL CONSTRAINT PK_STREET_ID PRIMARY KEY, 
Name VARCHAR(50) NULL, 
Street_Type VARCHAR(50) NULL, 
Geom GEOMETRY NULL) 

Sample insert statement:

INSERT INTO STREET VALUES ('HIGHWAY 101', 'HIGHWAY', geometry::STLineFromText('LINESTRING(1 5, 21 35)',0))